﻿using System;
using System.Text;
using System.Collections.Generic;
using System.Data;
namespace OneMake.Model
{
    [PetaPoco.TableName("htjy_d_refund")]
    [PetaPoco.PrimaryKey("oid")]
    public class htjy_d_refund
    {
        [MapToField(FieldName = "统计日期")]
        public DateTime stat_datetime { get; set; }

        [MapToExcel(ColumnName = "订单编号")]
        public string order_sn { get; set; }

        [MapToExcel(ColumnName = "退款编号")]
        public string refund_sn { get; set; }

        [MapToExcel(ColumnName = "支付宝交易号")]
        public string alipay { get; set; }

        [MapToExcel(ColumnName = "买家会员名称")]
        public string taobao { get; set; }

        [MapToExcel(ColumnName = "总金额")]
        public double amount { get; set; }

        [MapToExcel(ColumnName = "买家实际支付金额")]
        public double actual_paid { get; set; }

        [MapToExcel(ColumnName = "宝贝标题 ")]
        public string prd_title { get; set; }

        [MapToExcel(ColumnName = "买家退款金额")]
        public double return_amount { get; set; }

        [MapToExcel(ColumnName = "部分退款/全额退款")]
        public string return_type1 { get; set; }

        [MapToExcel(ColumnName = "手工退款/系统退款")]
        public string return_type2 { get; set; }

        [MapToExcel(ColumnName = "是否需要退货")]
        public string need_return_prd { get; set; }

        [MapToExcel(ColumnName = "退款的申请时间")]
        public DateTime apply_time { get; set; }

        [MapToExcel(ColumnName = "超时时间")]
        public DateTime timeout { get; set; }

        [MapToExcel(ColumnName = "退款状态")]
        public string return_status { get; set; }

        [MapToExcel(ColumnName = "货物状态")]
        public string prd_status { get; set; }

        [MapToExcel(ColumnName = "客服介入状态")]
        public string cs_status { get; set; }

        [MapToExcel(ColumnName = "卖家真实姓名")]
        public string seller_name { get; set; }

        [MapToExcel(ColumnName = "卖家退货地址")]
        public string seller_address { get; set; }

        [MapToExcel(ColumnName = "卖家邮编")]
        public string seller_post { get; set; }
        
        [MapToExcel(ColumnName = "卖家电话")]
        public string seller_telno { get; set; }

        [MapToExcel(ColumnName = "卖家手机")]
        public string seller_mobileno { get; set; }

        [MapToExcel(ColumnName = "退货物流类型")]
        public string return_ship_type { get; set; }

        [MapToExcel(ColumnName = "退货物流公司")]
        public string return_company { get; set; }

        [MapToExcel(ColumnName = "退货订单号")]
        public string return_order_sn { get; set; }

        [MapToExcel(ColumnName = "买家退款原因")]
        public string return_cause { get; set; }

        [MapToExcel(ColumnName = "买家退款说明")]
        public string return_comment { get; set; }

        [MapToExcel(ColumnName = "买家退货时间")]
        public DateTime return_time { get; set; }

        
		/////////////////////////////////////////
        [MapToField(FieldName = "门店编号")]
        public int shopid { get; set; }
        [MapToField(FieldName = "文件编号")]
        public int fileid { get; set; }
        [MapToField(FieldName = "编号")]
        public int oid { get; private set; }    
    }
}